package com.gulimall.product.vo;

import com.gulimall.product.entity.SkuImagesEntity;
import com.gulimall.product.entity.SkuInfoEntity;
import com.gulimall.product.entity.SpuInfoDescEntity;
import lombok.Data;
import lombok.ToString;

import java.util.List;

/**
 * @author coder_ccy
 * @date 2022/3/31 10:56
 */

@Data
@ToString
public class SkuItemInfoVo {
    //1. skuinfo  pms_sku_info
    private SkuInfoEntity skuInfoEntity;

    //2. skuimages  pms_sku_images
    private List<SkuImagesEntity> skuImages;

    //3.销售属性
//    select DISTINCT pms_sku_sale_attr_value.attr_id,pms_sku_sale_attr_value.attr_name,pms_sku_sale_attr_value.attr_value
//    from pms_sku_sale_attr_value  LEFT JOIN pms_sku_info on pms_sku_sale_attr_value.sku_id = pms_sku_info.sku_id  where pms_sku_info.spu_id = 3
//
    private List<SpuSaleAttrVo> spuSaleAttrVos;

    //4. 商品详细介绍  pms_spu_info_desc
    private SpuInfoDescEntity  spuInfoDesc;

    //5. 规格属性
//    select pms_product_attr_value.spu_id,pms_attr_group.attr_group_id,pms_attr_group.attr_group_name,pms_product_attr_value.attr_id,pms_product_attr_value.attr_name,pms_product_attr_value.attr_value
//    from pms_product_attr_value
//    LEFT JOIN pms_attr_attrgroup_relation on pms_product_attr_value.attr_id = pms_attr_attrgroup_relation.attr_id and pms_product_attr_value.spu_id=3
//    LEFT JOIN pms_attr_group on pms_attr_attrgroup_relation.attr_group_id =  pms_attr_group.attr_group_id

    private List<SpuAttrGroupVo> spuAttrGroupVos;





}
